Skip to main content
This forum is closed to new posts and responses. Individual names altered for privacy purposes. The information contained in this website is provided for informational purposes only and should not be construed as a forum for customer support requests. Any customer support requests should be directed to the official HCL customer support channels below:

HCL Software Customer Support Portal for U.S. Federal Government clients
HCL Software Customer Support Portal

Notes/Domino 8 Forum

Notes/Domino 8 Forum
Previous Next

DB2 -> Web (iSeries)

Thanks for your assistance... and I'm sorry there was not enough detail. The DB2 table contains information for our stores. Our current web application uses an old agent (ODBC Connection... really uses CLI) that runs each night. The HTML view (embedded in a form) shows the web users the stores based on the state selection. This works OK but is not dynamic enough as the information changes in DB2 throughout the day. Management wants it more instant... go figure (lol). I definitely want to populate the view with the DB2 table data since the data is entered each day in DB2. Is it possible to still use our formatted HTML view? Wow... should I be surprised that there is no native DB2 support on iSeries given that DB2 is part of the OS!?! If installing another instance on a Windows machine is the magic solution, we might can make it happen. As a reference, our table is like this (basic):

Field Desc Length

STOCSNO Customer No 10
STOCSCL Class 2
STOCSSC SubClass 2
STOCSNM Name 30
STOCAD1 Address 1 30
STOCAD2 Address 2 30
STOCAD3 Address 3 30
STOCAD4 Address 4 30
STOCITY City 20
STOSTAT State 30
STOZIP4 ZipCode 10
STOPUPN Phone Number 20
STOEML Email address 50
STOWEBA Web Page address 50

STOCSNO is the only numeric field.

Also, if I understand correctly (re: NSFDB2), there is no support for Notes Dbs stored in DB2 (with own DB2 scheme, etc.). This is OK because we want to continue running the native NSF format on our server. We're just trying to present a basic table (via Notes view) to web users.

I'm also reading up on data connections (DCRs)... sounds like you can create a DCR and map fields based on ID. Will this update in realtime (based on DECs, right)? ..a schedule somehow.


Feedback response number WEBB7CNPSM created by ~Sanjay Umtumisonikle on 03/12/2008

DB2 Table -> Web (~Sanjay Umtumis... 12.Mar.08)
. . A question and an answer (~Lily Cisfanate... 12.Mar.08)
. . . . DB2 -> Web (iSeries) (~Sanjay Umtumis... 12.Mar.08)
. . . . . . Option? LCConnection & Draft Script... (~Sanjay Umtumis... 12.Mar.08)
. . . . . . . . Syntax (LCConnection.Execute) (~Sanjay Umtumis... 13.Mar.08)
. . . . . . You could use Virtual Fields or Vir... (~Justin Xanluve... 14.Mar.08)
. . . . . . . . LEI vs. DECS (~Sanjay Umtumis... 14.Mar.08)
. . . . . . . . . . Comments on DECS (~Justin Xanluve... 17.Mar.08)
. . . . . . . . . . . . DECS Option (DB2 -> Notes Only) (~Sanjay Umtumis... 17.Mar.08)
. . . . . . . . . . . . . . more (~Justin Xanluve... 17.Mar.08)
. . . . . . . . . . . . . . . . Thanks (re: Email) (~Sanjay Umtumis... 18.Mar.08)
. . . . . . . . . . . . . . . . Latest Script & Question (re: Nothi... (~Sanjay Umtumis... 19.Mar.08)




Printer-friendly

Search this forum

Member Tools


RSS Feeds

 RSS feedsRSS
All forum posts RSS
All main topics RSS